/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sv.com.intesal.facturacion.sql;

/**
 *
 * @author ejerez
 */
public class SQLGasto {

    public static final String insertGasto="INSERT INTO GASTO(codigo_tg,nombre_g,estado_g)VALUES(?,?,?)";
    public static final String updateGasto="UPDATE GASTO SET codigo_tg=?, nombre_g=?, estado_g=? where codigo_g=?";
    public static final String getGastos="SELECT * FROM GASTO as g,TIPO_GASTO as tg,SUCURSAL as s where s.codigo_s=tg.codigo_s and tg.codigo_tg=g.codigo_tg  order by tg.nombre_tg,g.nombre_g";
    public static final String getGastos_x_Sucursal="SELECT * FROM GASTO as g,TIPO_GASTO as tg,SUCURSAL as s where s.codigo_s=tg.codigo_s and tg.codigo_tg=g.codigo_tg and s.codigo_s=? order by tg.nombre_tg,g.nombre_g";
}
